StudentSubsidiaryAccountRefund 
EntityType  Independent 
Logical Entity Name  StudentSubsidiaryAccountRefund 
Default Table Name  SaSubsidiaryRefund 
Logical Only  NO 
Owner  dbo 
Definition 
 
Note 
 

StudentSubsidiaryAccountRefund Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
StudentSubsidiaryAccountRefundId(PK)    INTEGER  NO 
 
StudentEnrollmentPeriodId(FK)    INTEGER  NO 
 
SubsidiaryAccountTypeId(FK)    INTEGER  NO 
 
DueDate    DATETIME  YES 
 
SentDate    DATETIME  YES 
 
Amount    MONEY(19, 4)  NO 
 
StudentRelationshipAddressId(FK)    INTEGER  YES 
 
BankAccountId(FK)    INTEGER  YES 
 
Status    CHAR(1)  NO 
 
Code    CHAR(8)  NO 
 
Description    VARCHAR(50)  NO 
 
AcademicYearSequence    SMALLINT  YES 
 
CheckNumber    VARCHAR(20)  YES 
 
Note    VARCHAR(50)  YES 
 
TermId(FK)    INTEGER  YES 
 
ReturnMethod    CHAR(1)  NO 
 
LastModifiedUserId(FK)    INTEGER  NO 
 
CreatedDateTime    DATETIME  NO 
 
LastModifiedDateTime    DATETIME  NO 
 
RowVersion    TIMESTAMP/DATE  NO 
 
PayeeName    VARCHAR(55)  YES 
 
StudentEnrollmentPeriodId(FK)    INTEGER  YES 
 

StudentSubsidiaryAccountRefund Keys 
Key Name  Key Type  Keys 
SaSubsidiaryRefund_AdTermID_N_N_IDX  Inversion Entry  TermId 
SaSubsidiaryRefund_SyAddressID_N_N_IDX  Inversion Entry  StudentRelationshipAddressId 
SaSubsidiaryRefund_UserID_N_N_IDX  Inversion Entry  LastModifiedUserId 
SaSubsidiaryRefund_SaBankAccountID_N_N_IDX  Inversion Entry  BankAccountId 
SaSubsidiaryRefund_AdEnrollID_SaSubsidiaryRefundID_U_N_IDX  Alternate Key  StudentEnrollmentPeriodId 
SaSubsidiaryRefund_SaSubsidiaryRefundID_U_C_IDX  PrimaryKey  StudentSubsidiaryAccountRefundId 
SaSubsidiaryRefund_SaSubsidiaryID_SaSubsidiaryRefundID_U_N_IDX  Alternate Key  SubsidiaryAccountTypeId, StudentEnrollmentPeriodId 

StudentSubsidiaryAccountRefund Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
BankAccount  Non-Identifying  Zero or One to Zero or More        BankAccountId  NO 
StudentEnrollmentPeriod  Non-Identifying  One To Zero or More        StudentEnrollmentPeriodId  NO 
Term  Non-Identifying  Zero or One to Zero or More        TermId  NO 
BankAccount  Non-Identifying  Zero or One to Zero or More        BankAccountId  NO 
SubsidiaryAccountType  Non-Identifying  One To Zero or More        SubsidiaryAccountTypeId  NO 
StudentRelationshipAddress  Non-Identifying  Zero or One to Zero or More        StudentRelationshipAddressId  NO 
Staff  Non-Identifying  One To Zero or More        LastModifiedUserId  NO 
StudentEnrollmentPeriod  Non-Identifying  Zero or One to Zero or More        StudentEnrollmentPeriodId  NO 
StudentRelationshipAddress  Non-Identifying  Zero or One to Zero or More        StudentRelationshipAddressId  NO 
SubsidiaryAccountType  Non-Identifying  Zero or One to Zero or More        SubsidiaryAccountTypeId  NO 
Term  Non-Identifying  Zero or One to Zero or More        TermId  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 
StudentSubsidiaryAccountTransaction  Non-Identifying  One To Zero or More          NO 
StudentAccountTransactionPendingCheck  Non-Identifying  One To Zero or More          NO 
StudentAccountTransactionPendingCheck  Non-Identifying  One To Zero or More          NO 
StudentSubsidiaryAccountTransaction  Non-Identifying  One To Zero or More          NO 

StudentSubsidiaryAccountRefund Check Constraints 
Check Constraint Name  CheckConstraint 

StudentSubsidiaryAccountRefund Where Used - Model Usage 
Mapped Object  Is User Defined?  Denormalization Mappings  Description  Bound Attachments 
Logical
dbo.StudentSubsidiaryAccountRefund 
NO       
Physical (Microsoft SQL Server)
dbo.SaSubsidiaryRefund 
NO       

StudentSubsidiaryAccountRefund Where Used - Submodel Usage 
Model  Submodel Usage 
Logical  Main Model 
Logical  Refunds_Stipends 
Logical  SubsidiaryLedger 
Physical (Microsoft SQL Server)  Main Model 
Physical (Microsoft SQL Server)  Student Accounts 

StudentSubsidiaryAccountRefund Data Movement Rules 
Name  Type  Rule Text/Value